CREATE OR REPLACE
VIEW pmdv_objects_vw
AS
SELECT
  o.objectid,
  o.invalid_or_changed,
  o.timing,
  o.owner,
  o.object_type,
  o.object_name,
  w.workid,
  w.name,
  w.description,
  w.create_date,
  w.end_date,
  w.deploy_minutes,
  w.deploy_seconds
FROM 
  pmdv_objects o,
  pmdv_work_vw w
WHERE w.workid = o.workid;
